This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
~Yoshi Quetkisterikle 12.Jan.04 03:57 PM a Web browser Notes Client6.0.3Windows 2000
I am attempting to retreive a range of records from an Oracle database to convert to Notes documents using an ODBC connection. I have a Select statement that retrieves all records between two dates. If I cut and paste my Select statement into Toad and run it against the data base, I get all the records as I would expect. When I run it in my Notes procedure, I get only today's records, if today's date is in the search, else I get zero records. Here is my Select statement:
OraQuery.SQL = "SELECT * FROM ORACLE_TABLE WHERE TRUNC(MY_DATE) > TO_DATE('" + sDATE.DateOnly + "','MM/DD/YYYY') - 1 AND TRUNC(MY_DATE) < TO_DATE('" + eDATE.DateOnly + "','MM/DD/YYYY') + 1"
Does anyone have any idea why Notes doesn't like this?
Return to top
Problems with ODBC Select statement... (~Yoshi Quetkist... 12.Jan.04)
. . 
Print this page
